package com.cs.beneficios.web.action;
import com.cs.beneficios.business.entity.SedeDAO;
import com.cs.beneficios.business.model.SedeVO;
import com.cs.beneficios.common.ConnectionFactory;
//import com.cs.paoyer.administration.exception.AdministrationUserException;
//import com.cs.paoyer.administration.util.AccessControl;
//import com.cs.paoyer.common.exception.CommonUserException;
//import com.cs.paoyer.common.exception.UserException;
import java.util.Collection;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
//import org.apache.struts.action.ActionError;
//import org.apache.struts.action.ActionErrors;
import java.io.IOException;
import javax.servlet.ServletException;
//import org.apache.struts.action.ActionMessage;
//import org.apache.struts.action.ActionMessages;

public class ConsultarSedeAction extends Action
{
  /**
   * This is the main action called from the Struts framework.
   * @param mapping The ActionMapping used to select this instance.
   * @param form The optional ActionForm bean for this request.
   * @param request The HTTP Request we are processing.
   * @param response The HTTP Response we are processing.
   * @return 
   * @throws java.io.IOException
   * @throws javax.servlet.ServletException
   */
  public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
  {

        //ConnectionFactory cf = new ConnectionFactory("beneficios","beneficios");
	 	ConnectionFactory cf = new ConnectionFactory();
        SedeVO objsedeVO = new SedeVO();
        String strOrigen = request.getParameter("ori");
        String strsede = request.getParameter("Sede");
        
        if((Object)strsede != null){
            
          objsedeVO.setNombre(strsede.trim());
          Collection sedes = null;
        
        try{
            SedeDAO objsedeDAO = new SedeDAO(cf);
            sedes = objsedeDAO.getSedes(objsedeVO);
            cf.closeConnection(objsedeDAO.getConn());
        
        }catch(Exception e){
			System.err.println("/******** TDSUB - cwsub");
			e.printStackTrace();
			System.err.println("TDSUB - cwsub ********/");
        }
        if(sedes.size()>0){
          request.setAttribute("sedes",sedes);   
        }else{
          request.setAttribute("msg","No existen registros con ese nombre.");
        }
        }
        
    return mapping.findForward("success");
  }
}